Method and system for assigning screen designation codes

ABSTRACT

A method and system for assigning screen designation codes is disclosed. A method of assigning screen designation codes includes assigning a first screen designation code to a first spreadsheet object, wherein the first screen designation code is associated with a first display screen of a multi-component display. A second screen designation code is assigned to a second spreadsheet object, wherein the second screen designation code is associated with a second display screen of the multi-component display. The first and second screen designation codes are operable to implement a simultaneous display of the first spreadsheet object on the first display screen and the second spreadsheet object on the second display screen.

RELATED APPLICATIONS

The present application is a continuation of U.S. patent application Ser. No. 10/049,271, filed Feb. 6, 2002, naming Gabriel D. Engel and Pita Witehira as inventors, assigned to the assignee of the present invention, and having attorney docket number PURE-P012, which claims the benefit of International Patent Application Number PCT/NZ00/00162, filed Aug. 18, 2000, which claims the benefit of New Zealand Patent Number 337333, filed Aug. 19, 1999. Each of these applications is incorporated herein by reference in their entirety and for all purposes.

BACKGROUND OF THE INVENTION

Reference throughout this specification shall be made to use of the present invention in relation to the display of data in spreadsheets. However, it should be appreciated that aspects of the present invention can be used in relation to displaying data presented in other formats, perhaps graphically or in some other format for displaying in particular relational data.

There are a number of spreadsheet programs, one of the more prolific being Microsoft Excel. These spreadsheet programs have a number of cells in rows and columns into which data can be input. Often the cells within the spreadsheet are related to each other.

For example, there may be a cell that displays a number which is calculated from the numbers represented in other cells in the spreadsheet. For instance, this particular cell may represent the total of a column of numbers. Any change to the numbers in that column will also be reflected in that cell representing the total.

This system works well when all of the data required to be reviewed can fit onto one computer screen display. However, often the user of the software creates spreadsheets which have more data entered into them than can be shown on one screen display at a time.

To accommodate this need, spreadsheet software often includes a facility akin to an old-fashioned system of having separate sheets of paper or cards except this is displayed on the computer, accessed by a virtual tab. For example, the screen may show one set of data. By clicking on a tab, a second set of data is then displayed on the screen with the first set of data being hidden by the second.

Unfortunately, this is still unsatisfactory. This is because the screen does not show all of the data that the user may wish to see. While the user can choose which spreadsheet to view, the user cannot see the effect that changing a cell on one spreadsheet has on another cell on the other spreadsheet.

Another problem is that it can take some time for a user to locate a particular cell. Not only is this another attempt to address the situation has been the ability to include multiple files on a screen which may be cross-linked in terms of having relational data.

Thus, it is possible for the user to alter data on one part of the screen in relation to one file and see its effect on another part of the screen in relation to another file.

Unfortunately, these attempts are still unsatisfactory. One problem with this system is that although there may be inter-relational data, there is no physical feel of the relationship between the cells.

For example, on each spreadsheet there may be cells relating to similar data in the same columns and rows for each spreadsheet. However, positioning the spreadsheets beside each other on the screen does not provide an intuitive feel of the relationship of the cells to each other.

Another problem that occurs is that often the single cell has two lots of data assigned to it. One data element is the actual number and the other data element is the formula or relationship equation which generates that number. In traditional spreadsheet programs, the formula is usually only displayed when that particular cell is selected.

Therefore, the formula for a number of related cells cannot be displayed at the same time. This is understandably frustrating, particularly when a person is desirous of quickly viewing and assessing the relationship between a number of cells to each other.

It is an object of the present invention to address the foregoing problems or at least to provide the public with a useful choice.

Further aspects and advantages of the present invention will become apparent from the ensuing description which is given by way of example only.

SUMMARY OF THE INVENTION

According to one aspect of the present invention there is provided a method for creating a visual effect in the display of software wherein the software is for the manipulation of data, the method characterized by the steps of a) assigning a particular screen designation code to a first group of data, and b) assigning other screen designation codes to second and other groups of data as desired, wherein the screen designation code determines which physical screen the group of data is displayed in a multi-level screen display.

As stated previously, the software in preferred embodiments is spreadsheet software, although it should be appreciated that the principles of the present invention can apply to other types of software, particularly those which relate to the display of data, such as databases, graphical analysis and so forth.

The term second and other group of data may cover such items as formula, relational information, highlights, error messages, hints and so forth which can be associated with the first group of data.

The screen designation code is merely a code that identifies which physical screen the image or software component is displayed upon.

The inventors of the present invention also invented a multi-level screen display and this is described in detail in PCT Application Nos. PCT/NZ98/00098 and PCT/NZ99/0002 1.

This is a device which is created by combining multiple layers of selectively transparent screens. Each screen is capable of showing an image. In preferred embodiments, the screen layers are liquid crystal displays. Preferably the screens are aligned parallel to each other with a preset distance between them.

With this invention, images displayed on the screen furthest from the view (background screen), will appear at some depth behind the images displayed on the screen closest to the viewer (foreground screen). The transparent portions on the foreground screen will allow viewers to see images displayed on the background screen.

This arrangement of layering multiple screens allows images to be presented at multiple levels giving the viewer true depth without use of glass or lens.

The present invention will now refer to use with a multi-level screen as described above although this should not be seen as limiting.

The group of data is in preferred embodiments a spreadsheet such as that normally viewed in a spreadsheet program, however this should not be seen as limiting.

It should be appreciated that although reference shall be made throughout this specification now to only background and foreground screens, other aspects of the present invention may utilize more than two screens. For example, various spreadsheets may be on the multiple screens behind the foreground screen.

A group of data may be that information displayed when a particular tab is selected on the screen. Therefore, that group of data or spreadsheet is displayed on one of the physical screens.

The group of data or spreadsheet that can be viewed by selecting another tab may be displayed on another physical screen. Alternatively, if there are two separate spreadsheet programs, these can be imported to an embodiment of the present invention and have separate spreadsheets from the separate files shown on the separate screens with one spreadsheet overlaying another, but with the ability to see both.

One embodiment of the present invention will be an interface that identifies the coding on existing software with these identifiers and assign various data groups to the appropriate foreground or background screen.

The “always on top” functions can be made fully or partially transparent by the present invention.

In one embodiment of the present invention, one screen may have a highlight for a particular cell or group of cells positioned either in front of or behind that highlight. In a variation of this embodiment, the highlights of a number of cells may be color coded with the codes corresponding to a particular relationship to cells of a certain type.

In another embodiment of the present invention, one group of data on one screen may be the actual values within the cells and the other group or groups of data on the other screens may be the coding or formulas or relational information that actually creates the value shown on the other screen.

In some embodiments, the groups of data may all belong to the same large spreadsheet and the second and consequent screens may merely show the wrap-around of that spreadsheet.

In other embodiments, it may be provided in cells a hyperlink that can take the user of the spreadsheet to other cells or other screens.

Sometimes, the present invention may be useful in error tracking. For example, a mistake in the relational formula between the cells or the data entered may lead to an error. The ability to see a number of cells at once can assist in tracking down where the error occurred or what cells are affected by the error.

In one aspect of the present invention there may be provided the ability to scroll through values on one cell or set of cells on a screen while still being able to view another set of cells on another screen. This is particularly useful where it is desired to be able to search for information or data on various areas of the spreadsheet or database while not disturbing the actual region of the spreadsheet or database that the user is working on.

The scrolling or rotation of data on various cells may be achieved in some instances by the use of a track ball or some other user interface.

In yet another embodiment one of the screens may display tips or hints associated with the cells being displayed on the other screen.

The interface may be a patch for existing software, a library file or a new front end for multiple existing software packages or a completely new operating system.

With existing software that does not have such coding, it may be necessary to implement the present invention by having customized software in which the software developer specifies the software routines which cause the appropriate components and images to go on the appropriate screens.

A further aspect of the present invention is the provision of media on to which instructions in accordance with the present invention have been recorded. For example, this media may be a graphics card, CD, hard drive, floppy disk and so forth.

The advantages of the present invention can now be readily seen.

Because of the physical separation between the screens, the viewer can easily see data On the front screen and oh the rear screen as required. Thus, the user can see significantly more data than previously viewable with standard software or standard screens. Indeed the amount of data that the user can see is a multiple proportional to the number of screens in the multi-level screen display.

The viewer can instantly see on which screen holds the cell or data that is relevant to it and select this.

The user can also see at a glance the relational nature of the data on the screens. For example, a change on one screen may cause corresponding change on the other screen overlaying it. This gives an instant appreciation of the effect of a change.

In some embodiments of the present invention the cells which change as a consequence of altering data may be color coded. This allows the user to more quickly identify where that change has occurred on multiple screens.

Some embodiments may have different shading to make it clear as to which screen the group of data is on, or to indicate which data is grouped together. The overall screens may also be shaded/colored to give visual clarity.

The present invention also allows the user to easily access a desired cell. Not only is this more desirable for the user in terms of mental satisfaction, but this also is significant in terms of physical relief. A problem that frequent computer users have is occupational overuse syndrome (oos) which is the repeated use of muscles, particularly when typing or using a mouse. Easier access means that the mouse is used less in order to find a particular cell and thus a potentially unpleasant medical condition is avoided.

In some embodiments of the present invention some cells are presented as 3-dimensional blocks which can be selected, moved or removed like blocks in a wall to reveal data on other screens.

It can be appreciated that the present invention overall literally provides an added dimension to the ability of a user to work with data manipulation programs such as spreadsheets and databases. There is considerably more flexibility and also a reduction in the time and effort required by the user to see the relationship between groups of data to each other.

Aspects of the present invention may extend to other standard functions on a spreadsheet program.

For example, spreadsheet programs often come with the ability to present the data graphically. Thus, for multi-relational data sheets, the present invention can also be used to produce 3-dimensional graphs showing the data on x, y and z axes as required.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 shows a first screen display of a conventional spreadsheet software.

FIG. 2 shows a first screen display of a conventional spreadsheet software.

FIG. 3 shows an exemplary display of spreadsheet objects on a multi-component display in accordance with one embodiment of the present invention.

DETAILED DESCRIPTION OF THE INVENTION

FIG. 1 is a screen display from a Microsoft Excel™ program. This illustrates a group of data on a spreadsheet generally indicated by arrow 1 on the screen. The associated tab (2) indicates that the data we are looking at relates to “FBT Calc-Lease”.

The screen also shows that there is a second group of data (not shown) and positioned visually under the first group of data. The indicator that there is a second group of data is the tab (3) which reads “FBT Calc-Lease to Own”.

To view the second group of data, it is necessary to select the tab (3). However, in doing so the first group of data is obscured by the second group of data. Thus, the effect of a change on one group of data is not immediately discernable as the user cannot see the other group of data.

It can also be seen that it can be difficult for the user to select a particular cell given that half of the data is obscured at any one time.

It should also be appreciated that spreadsheet programs of this type have the ability to have multiple tabs, not just the two shown.

FIG. 2 illustrates a screen display whereby two separate files have been imported into the one screen display and are positioned side by side.

This enables the user to change data on file and view its corresponding effect on the other file.

However, because the files are side by side, this is not intuitive with there being no real physical relationship between cells having the same common row and column.

Further, the screen size is still limited and only a certain amount of data can be fitted onto the screen.

The present invention provides for the separate groups of data (whether from separate files of merely separate spreadsheets to be displayed on separate physical screens aligned with each other.

FIG. 3 shows an example of a multi-level spreadsheet using only 2 layers.

Information can be stored on both layers. The layout of the cells can be used to enhance user information by positioning related cells close to or behind one another so as to improve the visual feedback to the user speeding up the development time and improving error detection. The positioning of the cells can also be used to increase the information available on a given cell as illustrated by the text and numbering chosen for FIG. 3. The front screen is ready to receive the monthly information such as income generated or expenses incurred while the back screen provides the user with immediate information about the day on which the income was generated or expense total incurred, thus reducing the need to look away from the cell to gain this information.

A greater number of layers of course can be used.

The 3-dimensional spreadsheet enables the user to see far greater quantities of data in the one visual display than before.

It also enables the user to quickly select a desired cell. Further, the relational nature of the data to each other can be intuitively perceived.

Aspects of the present invention have been described by way of example only and it should be appreciated that modifications and additions may be made thereto without departing from the scope of the appended claims. 

1. A method of assigning screen designation codes, said method comprising: assigning a first screen designation code to a first spreadsheet object, wherein said first screen designation code is associated with a first display screen of a multi-component display; assigning a second screen designation code to a second spreadsheet object, wherein said second screen designation code is associated with a second display screen of said multi-component display; and simultaneously displaying said first spreadsheet object on said first display screen and said second spreadsheet object on said second display screen, wherein said simultaneously displaying further comprises simultaneously displaying said first and second spreadsheet objects using said first and second screen designation codes.
 2. The method of claim 1, wherein said first and second spreadsheet objects are selected from a group consisting of a window, menu, a tab, an icon, a user-modifiable field, a cell, and a grouping of cells.
 3. The method of claim 1, wherein said first and second spreadsheet objects are associated with a respective user-selectable tab.
 4. The method of claim 1, wherein said first spreadsheet object comprises a formula, and wherein said second spreadsheet object is selected from a group consisting of data associated with said formula and a result of said formula.
 5. The method of claim 1, wherein said first and second spreadsheet objects comprise adjoining data wrapped from said first display screen to said second display screen.
 6. The method of claim 1, wherein said first spreadsheet object comprises a first color and said second spreadsheet object comprises a second color.
 7. The method of claim 1, wherein said first spreadsheet object comprises a link to said second spreadsheet object.
 8. The method of claim 1, wherein said second spreadsheet object is selected from a group consisting of: an error message related to said first spreadsheet object; and information about said first spreadsheet object.
 9. The method of claim 1, wherein said simultaneously displaying further comprises displaying said first spreadsheet object at a first position on said first display screen, wherein said simultaneously displaying further comprises displaying said second spreadsheet object at a second position on said second display screen, and further comprising: in response to a user interaction, accessing a third position for display of said first spreadsheet object on said first display screen.
 10. The method of claim 1, wherein said first and second spreadsheet objects are selected from a group consisting of an active cell, an active spreadsheet, and a user-selected cell.
 11. The method of claim 1, wherein said first display screen is physically spaced apart from said second display screen, and wherein said first and second display screens overlap.
 12. The method of claim 1, wherein said first spreadsheet object is at least partially transparent to enable viewing of said second spreadsheet object through said first spreadsheet object.
 13. The method of claim 1, wherein said first spreadsheet object is associated with a first spreadsheet, wherein said second spreadsheet object is associated with a second spreadsheet, and wherein said first and second spreadsheet objects overlap.
 14. The method of claim 1 further comprising: automatically modifying said second spreadsheet object in response to a modification of said first spreadsheet object.
 15. The method of claim 14, wherein said automatically modifying said second spreadsheet object further comprises changing a color of said second spreadsheet object.
 16. The method of claim 1, wherein an overlap of said first and second spreadsheet objects indicates a relationship of said first and second spreadsheet objects.
 17. The method of claim 1, wherein said first and second spreadsheet objects is selected from a group consisting of a three-dimensional graph, a three-dimensional chart, and a three-dimensional object.
 18. The method of claim 1, wherein said first and second spreadsheet objects are associated with a common spreadsheet cell.
 19. A computer-readable medium having computer-readable program code embodied therein for causing a computer system to perform a method of assigning screen designation codes, said method comprising: assigning a first screen designation code to a first spreadsheet object, wherein said first screen designation code is associated with a first display screen of a multi-component display; assigning a second screen designation code to a second spreadsheet object, wherein said second screen designation code is associated with a second display screen of said multi-component display; and simultaneously displaying said first spreadsheet object on said first display screen and said second spreadsheet object on said second display screen, wherein said simultaneously displaying further comprises simultaneously displaying said first and second spreadsheet objects using said first and second screen designation codes.
 20. The computer-readable medium of claim 19, wherein said first and second spreadsheet objects are selected from a group consisting of a window, menu, a tab, an icon, a user-modifiable field, a cell, and a grouping of cells.
 21. The computer-readable medium of claim 19, wherein said first and second spreadsheet objects are associated with a respective user-selectable tab.
 22. The computer-readable medium of claim 19, wherein said first spreadsheet object comprises a formula, and wherein said second spreadsheet object is selected from a group consisting of data associated with said formula and a result of said formula.
 23. The computer-readable medium of claim 19, wherein said first and second spreadsheet objects comprise adjoining data wrapped from said first display screen to said second display screen.
 24. The computer-readable medium of claim 19, wherein said first spreadsheet object comprises a first color and said second spreadsheet object comprises a second color.
 25. The computer-readable medium of claim 19, wherein said first spreadsheet object comprises a link to said second spreadsheet object.
 26. The computer-readable medium of claim 19, wherein said second spreadsheet object is selected from a group consisting of: an error message related to said first spreadsheet object; and information about said first spreadsheet object.
 27. The computer-readable medium of claim 19, wherein said simultaneously displaying further comprises displaying said first spreadsheet object at a first position on said first display screen, wherein said simultaneously displaying further comprises displaying said second spreadsheet object at a second position on said second display screen, and wherein said method further comprises: in response to a user interaction, accessing a third position for display of said first spreadsheet object on said first display screen.
 28. The computer-readable medium of claim 19, wherein said first and second spreadsheet objects are selected from a group consisting of an active cell, an active spreadsheet, and a user-selected cell.
 29. The computer-readable medium of claim 19, wherein said first display screen is physically spaced apart from said second display screen, and wherein said first and second display screens overlap.
 30. The computer-readable medium of claim 19, wherein said first spreadsheet object is at least partially transparent to enable viewing of said second spreadsheet object through said first spreadsheet object.
 31. The computer-readable medium of claim 19, wherein said first spreadsheet object is associated with a first spreadsheet, wherein said second spreadsheet object is associated with a second spreadsheet, and wherein said first and second spreadsheet objects overlap.
 32. The computer-readable medium of claim 19, wherein said method further comprises: automatically modifying said second spreadsheet object in response to a modification of said first spreadsheet object.
 33. The computer-readable medium of claim 32, wherein said automatically modifying said second spreadsheet object further comprises changing a color of said second spreadsheet object.
 34. The computer-readable medium of claim 19, wherein an overlap of said first and second spreadsheet objects indicates a relationship of said first and second spreadsheet objects.
 35. The computer-readable medium of claim 19, wherein said first and second spreadsheet objects is selected from a group consisting of a three-dimensional graph, a three-dimensional chart, and a three-dimensional object.
 36. The computer-readable medium of claim 19, wherein said first and second spreadsheet objects are associated with a common spreadsheet cell.
 37. A system comprising: means for assigning a first screen designation code to a first spreadsheet object, wherein said first screen designation code is associated with a first display screen of a multi-component display; means for assigning a second screen designation code to a second spreadsheet object, wherein said second screen designation code is associated with a second display screen of said multi-component display; and means for simultaneously displaying said first spreadsheet object on said first display screen and said second spreadsheet object on said second display screen, wherein said means for simultaneously displaying further comprises means for simultaneously displaying said first and second spreadsheet objects using said first and second screen designation codes.
 38. The system of claim 37, wherein said first and second spreadsheet objects are selected from a group consisting of a window, menu, a tab, an icon, a user-modifiable field, a cell, and a grouping of cells.
 39. The system of claim 37, wherein said first and second spreadsheet objects are associated with a respective user-selectable tab.
 40. The system of claim 37, wherein said first spreadsheet object comprises a formula, and wherein said second spreadsheet object is selected from a group consisting of data associated with said formula and a result of said formula.
 41. The system of claim 37, wherein said first and second spreadsheet objects comprise adjoining data wrapped from said first display screen to said second display screen.
 42. The system of claim 37, wherein said first spreadsheet object comprises a first color and said second spreadsheet object comprises a second color.
 43. The system of claim 37, wherein said first spreadsheet object comprises a link to said second spreadsheet object.
 44. The system of claim 37, wherein said second spreadsheet object is selected from a group consisting of: an error message related to said first spreadsheet object; and information about said first spreadsheet object.
 45. The system of claim 37, wherein said means for simultaneously displaying further comprises means for displaying said first spreadsheet object at a first position on said first display screen, wherein said means for simultaneously displaying further comprises means for displaying said second spreadsheet object at a second position on said second display screen, and wherein said system further comprises: means for accessing, in response to a user interaction, a third position for display of said first spreadsheet object on said first display screen.
 46. The system of claim 37, wherein said first and second spreadsheet objects are selected from a group consisting of an active cell, an active spreadsheet, and a user-selected cell.
 47. The system of claim 37, wherein said first display screen is physically spaced apart from said second display screen, and wherein said first and second display screens overlap.
 48. The system of claim 37, wherein said first spreadsheet object is at least partially transparent to enable viewing of said second spreadsheet object through said first spreadsheet object.
 49. The system of claim 37, wherein said first spreadsheet object is associated with a first spreadsheet, wherein said second spreadsheet object is associated with a second spreadsheet, and wherein said first and second spreadsheet objects overlap.
 50. The system of claim 37 further comprising: means for automatically modifying said second spreadsheet object in response to a modification of said first spreadsheet object.
 51. The system of claim 374, wherein said means for automatically modifying said second spreadsheet object further comprises means for changing a color of said second spreadsheet object.
 52. The system of claim 37, wherein an overlap of said first and second spreadsheet objects indicates a relationship of said first and second spreadsheet objects.
 53. The system of claim 37, wherein said first and second spreadsheet objects is selected from a group consisting of a three-dimensional graph, a three-dimensional chart, and a three-dimensional object.
 54. The system of claim 37, wherein said first and second spreadsheet objects are associated with a common spreadsheet cell. 